{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":171,"n_cols":12,"rows_kept":171,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[21,2,21,3],[37,2,37,3],[55,2,55,3],[73,2,73,3],[89,2,89,3],[103,2,103,3],[120,2,120,3],[136,2,136,3],[153,2,153,3],[169,2,169,3],[170,2,170,4]]}
["Школа",null,"МОУ\"Ладва - Веткинская основная общеобразовательная школа №7",null,null,"Утвердил:","должность","Директор МОУ \"Ладва - Веткинская ООШ №7\""]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Коршаков Д.В."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",8,9,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Макароны отварные с сыром",200,12,10,35.3,280,"259/2021",46]
[{"$nulls":3},"гор.напиток","Чай с молоком",200,1.6,1.3,11.5,64,"460/2021",11]
[{"$nulls":3},"хлеб","Хлеб пшеничный",25,1.9,0.2,12.3,58.5,"573/2021",6]
[{"$nulls":3},"гастрономия","Масло сливочное",10,0.08,7.25,0.13,66.1,"79/2021",8]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47,"9.1.2.6/2012",24]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F11)","v":535},{"$f":"SUM(G6:G11)","v":15.98},{"$f":"SUM(H6:H11)","v":19.15},{"$f":"SUM(I6:I11)","v":69.03},{"$f":"SUM(J6:J11)","v":515.6},null,{"$f":"SUM(L6:L11)","v":95}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска","Салат из белокочанной капусты",60,0.87,3.6,5.04,56.4,"1/2021",5]
[{"$nulls":3},"1 блюдо","Суп картофельный с горохом",250,2.34,3.89,13.61,98.79,"45/2008",20.4]
[{"$nulls":3},"2 блюдо","Котлета Школьная ",90,13.77,9.9,11.97,191.7,"347/2021",40]
[{"$nulls":3},"соус","Соус томатный",30,0.29,0.98,1.38,15.57,"419/2021",2]
[{"$nulls":3},"гарнир","Рис отварной",150,3.89,5.08,40.28,225.18,"224/2008",18]
[{"$nulls":3},"напиток","Чай с сахаром",200,0.2,0.1,9.3,38,"457/2021",3]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.5,"573/2021",3]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,2.4,0.46,12.03,61.8,"574/2021",3.6]
[{"$nulls":3},"итого",null,{"$f":"SUM(F13:F20)","v":835},{"$f":"SUM(G13:G20)","v":25.66},{"$f":"SUM(H13:H20)","v":24.21},{"$f":"SUM(I13:I20)","v":105.91},{"$f":"SUM(J13:J20)","v":745.94},null,{"$f":"SUM(L13:L20)","v":95}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F12+F21","v":1370},{"$f":"G12+G21","v":41.64},{"$f":"H12+H21","v":43.36},{"$f":"I12+I21","v":174.94},{"$f":"J12+J21","v":1261.54},null,{"$f":"L12+L21","v":190}]
[1,2,"Завтрак","гор.блюдо","Омлет натуральный",65,5.6,8.5,1.4,104,"268/2021",35]
[{"$nulls":3},"гор.блюдо","Каша кукурузная",130,3.86,4.19,23.53,147.25,"233/2021",23]
[{"$nulls":3},"гор.напиток","Какао с молоком",200,3.3,2.9,13.8,94,"462/2021",7]
[{"$nulls":3},"хлеб","Хлеб ржаной",25,2,0.38,10.03,51.5,"574/2021",3]
[{"$nulls":3},"хлеб","Хлеб пшеничный",25,1.9,0.2,12.3,58.5,"573/2021",3]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47,"9.1.2.6/2012",24]
[{"$nulls":3},"итого",null,{"$f":"SUM(F23:F28)","v":545},{"$f":"SUM(G23:G28)","v":17.06},{"$f":"SUM(H23:H28)","v":16.57},{"$f":"SUM(I23:I28)","v":70.86},{"$f":"SUM(J23:J28)","v":502.25},null,{"$f":"SUM(L23:L28)","v":95}]
[{"$f":"A23","v":1},{"$f":"B23","v":2},"Обед"]
[{"$nulls":3},"1 блюдо","Борщ из св.капусты со сметаной",250,1.9,6.66,10.81,111.11,"37/2008",17]
[{"$nulls":3},"2 блюдо","Птица в соусе с томатом",100,9.5,11.1,2.21,146.43,"367/2021",41]
[{"$nulls":3},"гарнир","Макароны отварные",150,5.52,5.29,35.32,211.09,"227/2008",18]
[{"$nulls":3},"напиток","Компот из изюма",200,0.5,0.1,21.5,88.8,"494/2021",10]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.5,"573/2021",3]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4,0.75,20.05,103,"574/2021",6]
[{"$nulls":3},"итого",null,{"$f":"SUM(F30:F36)","v":775},{"$f":"SUM(G30:G36)","v":23.32},{"$f":"SUM(H30:H36)","v":24.1},{"$f":"SUM(I30:I36)","v":102.19},{"$f":"SUM(J30:J36)","v":718.93},null,{"$f":"SUM(L30:L36)","v":95}]
[{"$f":"A23","v":1},{"$f":"B23","v":2},"Итого за день:",null,null,{"$f":"F29+F37","v":1320},{"$f":"G29+G37","v":40.38},{"$f":"H29+H37","v":40.67},{"$f":"I29+I37","v":173.05},{"$f":"J29+J37","v":1221.18},null,{"$f":"L29+L37","v":190}]
[1,3,"Завтрак","гор.блюдо","Плов из отварной птицы",150,9.22,6.15,18.6,167.25,"375/2021",31.6]
[{"$nulls":3},"гастрономия","Сыр порционный",10,2.32,2.95,0,35.8,"75/2021",20]
[{"$nulls":3},"гастрономия","Масло сливочное",10,0.08,7.25,0.13,66.1,"79/2021",8]
[{"$nulls":3},"хлеб бел.","Хлеб ржаной",30,2.4,0.46,12.03,61.8,"574/2021",3.6]
[{"$nulls":3},"хлеб черн.","Хлеб пшеничный",40,3.04,0.32,19.68,93.6,"573/2021",4.8]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.2,0.1,9.3,38,"457/2021",3]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47,"9.1.2.6/2012",24]
[{"$nulls":3},"итого",null,530,16.9,17.55,64.62,486.15,null,{"$f":"SUM(L39:L45)","v":95}]
[{"$f":"A39","v":1},{"$f":"B39","v":3},"Обед","закуска","Салат из свеклы отварной",70,0.98,4.27,5.32,63.7,"26/2021",6]
[{"$nulls":3},"1 блюдо","Щи из св.капусты со сметаной",250,2.9,6.33,10.64,107.83,"63/2008",11]
[{"$nulls":3},"2 блюдо","Биточки рыбные",90,11.57,1.41,9,95.14,"307/2021",26]
[{"$nulls":3},"гастрономия","Масло сливочное",10,0.08,7.25,0.13,66.1,"79/2021",8]
[{"$nulls":3},"гарнир","Пюре картофельное",150,3.19,6.06,23.29,160.45,"241/2008",25]
[{"$nulls":3},"напиток","Компот из сухофруктов",200,0.6,0.1,20.1,84,"495/2021",10]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.5,"573/2021",3]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4,0.75,20.05,103,"574/2021",6]
[{"$nulls":3},"итого",null,{"$f":"SUM(F47:F54)","v":845},{"$f":"SUM(G47:G54)","v":25.22},{"$f":"SUM(H47:H54)","v":26.37},{"$f":"SUM(I47:I54)","v":100.83},{"$f":"SUM(J47:J54)","v":738.72},null,{"$f":"SUM(L47:L54)","v":95}]
[{"$f":"A39","v":1},{"$f":"B39","v":3},"Итого за день:",null,null,{"$f":"F46+F55","v":1375},{"$f":"G46+G55","v":42.12},{"$f":"H46+H55","v":43.92},{"$f":"I46+I55","v":165.45},{"$f":"J46+J55","v":1224.87},null,{"$f":"L46+L55","v":190}]
[1,4,"Завтрак","гор.блюдо","Запеканка из творога",70,11.13,5.4,10.5,135.8,"279/2021",31]
[{"$nulls":3},"соус","Соус молочный сладкий",30,0.72,1.45,2.37,25.38,"406/2021",3]
[{"$nulls":3},"гор.блюдо","Каша манная",100,3.6,3.18,17.27,112,"214/2021",16]
[{"$nulls":3},"напиток","Напиток из шиповника",200,0.67,0.27,18.3,78,"496/2021",10]
[{"$nulls":3},"хлеб","Хлеб пшеничный",25,1.9,0.2,12.3,58.5,"573/2021",3]
[{"$nulls":3},"гастрономия","Масло сливочное",10,0.08,7.25,0.13,66.1,"79/2021",8]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47,"9.1.2.6/2012",24]
[{"$nulls":3},"итого",null,{"$f":"SUM(F57:F63)","v":535},{"$f":"SUM(G57:G63)","v":18.5},{"$f":"SUM(H57:H63)","v":18.15},{"$f":"SUM(I57:I63)","v":70.67},{"$f":"SUM(J57:J63)","v":522.78},null,{"$f":"SUM(L57:L63)","v":95}]
[{"$f":"A57","v":1},{"$f":"B57","v":4},"Обед"]
[{"$nulls":3},"1 блюдо","Суп молочный с рисом",200,4.8,5,16.44,130,"140/2021",26]
[{"$nulls":3},"2 блюдо","Котлеты Пермские ",90,14.4,13.95,10.8,240.67,"341/2021",32]
[{"$nulls":3},"соус","Соус томатный",25,0.24,0.8,1.1,12.97,"419/2021",2]
[{"$nulls":3},"гарнир","Картофель отварной",150,3.14,7.03,27.21,182.46,"239/2008",17]
[{"$nulls":3},"напиток","Компот из яблок с лимоном",200,0.25,0.25,25.35,104.07,"284/2008",12]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.5,"573/2021",3]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,2,0.38,10.02,51.5,"574/2021",3]
[{"$nulls":3},"итого",null,{"$f":"SUM(F65:F72)","v":715},{"$f":"SUM(G65:G72)","v":26.73},{"$f":"SUM(H65:H72)","v":27.61},{"$f":"SUM(I65:I72)","v":103.22},767.2,null,{"$f":"SUM(L65:L72)","v":95}]
[{"$f":"A57","v":1},{"$f":"B57","v":4},"Итого за день:",null,null,{"$f":"F64+F73","v":1250},{"$f":"G64+G73","v":45.23},{"$f":"H64+H73","v":45.76},{"$f":"I64+I73","v":173.89},{"$f":"J64+J73","v":1289.98},null,{"$f":"L64+L73","v":190}]
[1,5,"Завтрак","гор.блюдо","Каша гречневая вязкая на молоке",200,8.7,7.5,31.4,227.7,"213/2021",31]
[{"$nulls":3},"гор.напиток","Чай с лимоном",200,0.3,0.1,9.5,40,"459/2021",10]
[{"$nulls":3},"хлеб","Хлеб пшеничный",50,3.8,0.4,24.6,117,"573/2021",6]
[{"$nulls":3},"гастрономия","Сыр порционный",15,3.48,4.43,0,53.7,"75/2021",20]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47,"9.1.2.6/2012",24]
[{"$nulls":3},"гастрономия","Масло сливочное",5,0.04,3.63,0.07,33.05,"79/2021",4]
[{"$nulls":3},"итого",null,{"$f":"SUM(F75:F80)","v":570},{"$f":"SUM(G75:G80)","v":16.72},{"$f":"SUM(H75:H80)","v":16.46},{"$f":"SUM(I75:I80)","v":75.37},{"$f":"SUM(J75:J80)","v":518.45},null,{"$f":"SUM(L75:L80)","v":95}]
[{"$f":"A75","v":1},{"$f":"B75","v":5},"Обед"]
[{"$nulls":3},"1 блюдо","Суп из овощей со сметаной",250,1.93,5.86,12.59,115.24,"44/2008",20]
[{"$nulls":3},"2 блюдо","Фрикадельки из говядины ",100,12.63,13.54,9.16,208.6,"204/2008",44.4]
[{"$nulls":3},"гарнир","Макароны отварные",150,5.52,5.29,35.32,211.09,"227/2008",18]
[{"$nulls":3},"напиток","Чай с сахаром",200,0.2,0.1,9.3,38,"457/2021",3]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,"573/2021",3.6]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4,0.75,20.05,103,"574/2021",6]
[{"$nulls":3},"итого",null,{"$f":"SUM(F82:F88)","v":780},{"$f":"SUM(G82:G88)","v":26.56},{"$f":"SUM(H82:H88)","v":25.78},{"$f":"SUM(I82:I88)","v":101.18},{"$f":"SUM(J82:J88)","v":746.13},null,{"$f":"SUM(L82:L88)","v":95}]
[{"$f":"A75","v":1},{"$f":"B75","v":5},"Итого за день:",null,null,{"$f":"F81+F89","v":1350},{"$f":"G81+G89","v":43.28},{"$f":"H81+H89","v":42.24},{"$f":"I81+I89","v":176.55},{"$f":"J81+J89","v":1264.58},null,{"$f":"L81+L89","v":190}]
[2,1,"Завтрак","гор.блюдо","Каша из овсяных хлопьев \"Геркулес\" вязкая",200,8.26,8.84,30.92,236.3,"212/2021",35]
[{"$nulls":3},"гор.напиток","Кофейный напиток с молоком",200,2.8,2.5,13.6,88,"465/2021",10]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",50,3.8,0.4,24.6,117,"573/2021",6]
[{"$nulls":3},"гастрономия","Сыр порционный",15,3.48,4.43,0,53.7,"75/2021",20]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47,"9.1.2.6/2012",24]
[{"$nulls":3},"итого",null,{"$f":"SUM(F91:F95)","v":565},{"$f":"SUM(G91:G95)","v":18.74},{"$f":"SUM(H91:H95)","v":16.57},{"$f":"SUM(I91:I95)","v":78.92},{"$f":"SUM(J91:J95)","v":542},null,{"$f":"SUM(L91:L95)","v":95}]
[2,1,"Обед","1 блюдо","Суп картофельный с макаронными изделиями",250,2.83,2.86,21.76,124.09,"47/2008",14]
[{"$nulls":3},"2 блюдо","Тефтели из говядины в молочном соусе",100,12.85,14.6,8.4,177,"200/2008",42]
[{"$nulls":3},"гарнир","Рагу из овощей 2 вариант",150,2.85,6.8,14,127.5,"235/2008",17]
[{"$nulls":3},"напиток","Компот из изюма",200,0.5,0.1,21.5,88.8,"494/2021",10]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",50,3.8,0.4,24.6,117,"573/2021",6]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4,0.75,20.05,103,"574/2021",6]
[{"$nulls":3},"итого",null,{"$f":"SUM(F97:F102)","v":800},{"$f":"SUM(G97:G102)","v":26.83},{"$f":"SUM(H97:H102)","v":25.51},{"$f":"SUM(I97:I102)","v":110.31},737.39,null,{"$f":"SUM(L97:L102)","v":95}]
[{"$f":"A91","v":2},{"$f":"B91","v":1},"Итого за день:",null,null,{"$f":"F96+F103","v":1365},{"$f":"G96+G103","v":45.57},{"$f":"H96+H103","v":42.08},{"$f":"I96+I103","v":189.23},{"$f":"J96+J103","v":1279.39},null,{"$f":"L96+L103","v":190}]
[2,2,"Завтрак","гастрономия","Яйцо вареное",40,5.1,4.6,0.3,63,"267/2021",24]
[{"$nulls":3},"гор.блюдо","Каша пшеничная вязкая",200,8.2,6.6,37,239.4,"223/2021",54]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.2,0.1,9.3,38,"457/2021",3]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.5,"573/2021",3]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,2,0.38,10.02,51.5,"574/2021",3]
[{"$nulls":3},"гастрономия","Масло сливочное",10,0.08,7.25,0.13,66.1,"9.1.2.6/2012",8]
[{"$nulls":3},"итого",null,{"$f":"SUM(F105:F110)","v":500},{"$f":"SUM(G105:G110)","v":17.48},{"$f":"SUM(H105:H110)","v":19.13},{"$f":"SUM(I105:I110)","v":69.05},{"$f":"SUM(J105:J110)","v":516.5},null,{"$f":"SUM(L105:L110)","v":95}]
[{"$f":"A105","v":2},2,"Обед","закуска","Салат из свеклы",60,0.84,3.7,4.6,54.6,"26/2021",5]
[{"$nulls":3},"1 блюдо","Рассольник домашний со сметаной",250,5.03,11.3,32.38,149.6,"41/2008",12]
[{"$nulls":3},"2 блюдо","Котлета рыбная ",90,11.57,1.41,9,95.14,"307/2021",31]
[{"$nulls":3},"гастрономия","Масло сливочное",5,0.04,3.63,0.07,33.05,"79/2021",4]
[{"$nulls":3},"гарнир","Пюре картофельное",150,3.19,6.06,23.29,160.45,"241/2008",25]
[{"$nulls":3},"напиток","Компот из яблок и лимона",200,0.25,0.25,25.35,104.7,"284/2008",12]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.5,"573/2021",3]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,2,0.38,10.02,51.5,"574/2021",3]
[{"$nulls":3},"итого",null,{"$f":"SUM(F112:F119)","v":805},{"$f":"SUM(G112:G119)","v":24.82},{"$f":"SUM(H112:H119)","v":26.93},{"$f":"SUM(I112:I119)","v":117.01},{"$f":"SUM(J112:J119)","v":707.54},null,{"$f":"SUM(L112:L119)","v":95}]
[{"$f":"A105","v":2},{"$f":"B105","v":2},"Итого за день:",null,null,{"$f":"F111+F120","v":1305},{"$f":"G111+G120","v":42.3},{"$f":"H111+H120","v":46.06},{"$f":"I111+I120","v":186.06},{"$f":"J111+J120","v":1224.04},null,{"$f":"L111+L120","v":190}]
[2,3,"Завтрак","гор.блюдо","Греча по-купечески",150,14.4,12.95,33.06,298.44,"контр.проработка",44.4]
[{"$nulls":3},"закуска","Огурец порционный",20,0.14,0.02,0.38,2.2,"148/2021",9]
[{"$nulls":3},"гастрономия","Масло сливочное",5,0.04,3.63,0.07,33.05,"79/2021",4]
[{"$nulls":3},"гор.напиток","Чай с лимоном",200,0.3,0.1,9.5,40,"459/2021",10]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,"573/2021",3.6]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47,"9.1.2.6/2012",24]
[{"$nulls":3},"итого",null,{"$f":"SUM(F122:F127)","v":505},{"$f":"SUM(G122:G127)","v":17.56},{"$f":"SUM(H122:H127)","v":17.34},{"$f":"SUM(I122:I127)","v":67.57},{"$f":"SUM(J122:J127)","v":490.89},null,{"$f":"SUM(L122:L127)","v":95}]
[{"$f":"A122","v":2},3,"Обед","закуска","Салат из свежих огурцов",60,0.42,3.6,1.08,38.4,"14/2021",8]
[{"$nulls":3},"1 блюдо","Борщ из св.капусты со сметаной",250,1.9,6.66,10.81,111.11,"37/2008",13]
[{"$nulls":3},"2 блюдо","Печень тушеная в соусе",100,16.6,8,11.36,176,"359/2021",40]
[{"$nulls":3},"гарнир","Рис отварной",150,3.89,5.08,40.28,225.18,"224/2008",18]
[{"$nulls":3},"напиток","Компот из свежих яблок",200,0.16,0,14.99,60.64,"282/2008",10]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.5,"573/2021",3]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,2,0.38,10.02,51.5,"574/2021",3]
[{"$nulls":3},"итого",null,{"$f":"SUM(F129:F135)","v":810},{"$f":"SUM(G129:G135)","v":26.87},{"$f":"SUM(H129:H135)","v":23.92},{"$f":"SUM(I129:I135)","v":100.84},{"$f":"SUM(J129:J135)","v":721.33},null,{"$f":"SUM(L129:L135)","v":95}]
[{"$f":"A122","v":2},{"$f":"B122","v":3},"Итого за день:",null,null,{"$f":"F128+F136","v":1315},{"$f":"G128+G136","v":44.43},{"$f":"H128+H136","v":41.26},{"$f":"I128+I136","v":168.41},{"$f":"J128+J136","v":1212.22},null,{"$f":"L128+L136","v":190}]
[2,4,"Завтрак","гор.блюдо","Пудинг творожный запеченный",75,11.3,4,15.5,143,"285/2021",33.4]
[{"$nulls":3},"соус","Соус молочный сладкий",30,0.72,1.45,2.37,25.38,"406/2021",3]
[{"$nulls":3},"гор.блюдо","Каша манная вязкая",100,3.6,3.18,17.27,112,"214/2021",13]
[{"$nulls":3},"гор.напиток","Чай с лимоном",200,0.3,0.1,9.5,40,"459/2021",10]
[{"$nulls":3},"гастрономия","Масло сливочное",10,0.08,7.25,0.13,66.1,"79/2021",8]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,"573/2021",3.6]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47,"9.1.2.6/2012",24]
[{"$nulls":3},"итого",null,{"$f":"SUM(F138:F144)","v":545},{"$f":"SUM(G138:G144)","v":18.68},{"$f":"SUM(H138:H144)","v":16.62},{"$f":"SUM(I138:I144)","v":69.33},{"$f":"SUM(J138:J144)","v":503.68},null,{"$f":"SUM(L138:L144)","v":95}]
[{"$f":"A138","v":2},4,"Обед","закуска","Салат из белокочанной капусты",60,0.87,3.6,5.04,56.4,"2021-01-01",5]
[{"$nulls":3},"1 блюдо","Суп из овощей со сметаной",250,1.93,5.86,12.59,115.24,"44/2008",20]
[{"$nulls":3},"2 блюдо","Птица в соусе с томатом",100,9.5,11.1,2.3,146.5,"367/2021",33]
[{"$nulls":3},"гарнир","Макароны отварные",150,5.52,5.29,35.32,211.09,"227/2008",18]
[{"$nulls":3},"напиток","Компот из изюма",200,0.5,0.1,21.5,88.8,"494/2021",10]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.5,"573/2021",6]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4,0.75,20.05,103,"574/2021",3]
[{"$nulls":3},"итого",null,{"$f":"SUM(F146:F152)","v":835},{"$f":"SUM(G146:G152)","v":24.22},{"$f":"SUM(H146:H152)","v":26.9},{"$f":"SUM(I146:I152)","v":109.1},{"$f":"SUM(J146:J152)","v":779.53},null,{"$f":"SUM(L146:L152)","v":95}]
[{"$f":"A138","v":2},{"$f":"B138","v":4},"Итого за день:",null,null,{"$f":"F145+F153","v":1380},{"$f":"G145+G153","v":42.9},{"$f":"H145+H153","v":43.52},{"$f":"I145+I153","v":178.43},{"$f":"J145+J153","v":1283.21},null,{"$f":"L145+L153","v":190}]
[2,5,"Завтрак","гор.блюдо","Каша Дружба",200,5.08,6.44,26.92,185.96,"229/2021",34]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",50,3.8,0.4,24.6,117,"573/2021",6]
[{"$nulls":3},"гастрономия","Масло сливочное",5,0.04,3.63,0.07,33.05,"79/2021",4]
[{"$nulls":3},"гастрономия","Сыр порционный",15,3.48,4.43,0,53.7,"75/2021",20]
[{"$nulls":3},"гор.напиток","Какао с молоком",200,3.3,2.9,13.8,94,"462/2021",7]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47,"9.1.2.6/2012",24]
[{"$nulls":3},"итого",null,{"$f":"SUM(F155:F160)","v":570},{"$f":"SUM(G155:G160)","v":16.1},{"$f":"SUM(H155:H160)","v":18.2},{"$f":"SUM(I155:I160)","v":75.19},{"$f":"SUM(J155:J160)","v":530.71},null,{"$f":"SUM(L155:L160)","v":95}]
[2,5,"Обед","1 блюдо","Свекольник со сметаной",250,1.93,6.34,10.05,104.16,"43/2008",14]
[{"$nulls":3},"2 блюдо","Котлеты из говядины",90,15.84,11.07,13.92,218.7,"339/2021",43]
[{"$nulls":3},"соус","Соус томатный",30,0.29,0.98,1.38,15.57,"419/2021",2]
[{"$nulls":3},"гарнир","Картофель отварной",150,3.14,7.03,27.21,182.46,"239/2021",17]
[{"$nulls":3},"напиток","Компот из сухофруктов",200,0.6,0.1,20.1,84,"495/2021",10]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.5,"573/2021",3]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",40,3.2,0.6,16.04,82.4,"574/2021",6]
[{"$nulls":3},"итого",null,{"$f":"SUM(F162:F168)","v":785},{"$f":"SUM(G162:G168)","v":26.9},{"$f":"SUM(H162:H168)","v":26.32},{"$f":"SUM(I162:I168)","v":101},{"$f":"SUM(J162:J168)","v":745.79},null,{"$f":"SUM(L162:L168)","v":95}]
[{"$f":"A155","v":2},{"$f":"B155","v":5},"Итого за день:",null,null,{"$f":"F161+F169","v":1355},{"$f":"G161+G169","v":43},{"$f":"H161+H169","v":44.52},{"$f":"I161+I169","v":176.19},{"$f":"J161+J169","v":1276.5},null,{"$f":"L161+L169","v":190}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F22+F38+F56+F74+F90+F104+F121+F137+F154+F170)/(IF(F22=0,0,1)+IF(F38=0,0,1)+IF(F56=0,0,1)+IF(F74=0,0,1)+IF(F90=0,0,1)+IF(F104=0,0,1)+IF(F121=0,0,1)+IF(F137=0,0,1)+IF(F154=0,0,1)+IF(F170=0,0,1))","v":1338.5},{"$f":"(G22+G38+G56+G74+G90+G104+G121+G137+G154+G170)/(IF(G22=0,0,1)+IF(G38=0,0,1)+IF(G56=0,0,1)+IF(G74=0,0,1)+IF(G90=0,0,1)+IF(G104=0,0,1)+IF(G121=0,0,1)+IF(G137=0,0,1)+IF(G154=0,0,1)+IF(G170=0,0,1))","v":43.085},{"$f":"(H22+H38+H56+H74+H90+H104+H121+H137+H154+H170)/(IF(H22=0,0,1)+IF(H38=0,0,1)+IF(H56=0,0,1)+IF(H74=0,0,1)+IF(H90=0,0,1)+IF(H104=0,0,1)+IF(H121=0,0,1)+IF(H137=0,0,1)+IF(H154=0,0,1)+IF(H170=0,0,1))","v":43.339},{"$f":"(I22+I38+I56+I74+I90+I104+I121+I137+I154+I170)/(IF(I22=0,0,1)+IF(I38=0,0,1)+IF(I56=0,0,1)+IF(I74=0,0,1)+IF(I90=0,0,1)+IF(I104=0,0,1)+IF(I121=0,0,1)+IF(I137=0,0,1)+IF(I154=0,0,1)+IF(I170=0,0,1))","v":176.22},{"$f":"(J22+J38+J56+J74+J90+J104+J121+J137+J154+J170)/(IF(J22=0,0,1)+IF(J38=0,0,1)+IF(J56=0,0,1)+IF(J74=0,0,1)+IF(J90=0,0,1)+IF(J104=0,0,1)+IF(J121=0,0,1)+IF(J137=0,0,1)+IF(J154=0,0,1)+IF(J170=0,0,1))","v":1253.751},null,{"$f":"(L22+L38+L56+L74+L90+L104+L121+L137+L154+L170)/(IF(L22=0,0,1)+IF(L38=0,0,1)+IF(L56=0,0,1)+IF(L74=0,0,1)+IF(L90=0,0,1)+IF(L104=0,0,1)+IF(L121=0,0,1)+IF(L137=0,0,1)+IF(L154=0,0,1)+IF(L170=0,0,1))","v":190}]